﻿// Copyright 2009 Mike Geise
// 
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
// 
//     http://www.apache.org/licenses/LICENSE-2.0
// 
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
// See the License for the specific language governing permissions and
// limitations under the License.

namespace Falcon.Core.SqlServer.Repositories
{
	using System;
	using System.Collections.Generic;
	using System.Data;
	using System.Data.SqlClient;
	using Falcon.Core.Collections;
	using Falcon.Core.Domain;
	using Falcon.Core.Domain.Repositories;
	using Falcon.Core.Extensions;
	using Falcon.Core.SqlServer.Repositories.Parameters;
	using Falcon.Core.SqlServer.Repositories.Readers;

	public class UserSearchRepository : SqlRepositoryBase, IUserSearchRepository
	{
		public IList<UserSearch> GetAll(UserSearchSpecification specification)
		{
			return base.GetAll(Tables.UsersSearches, new UserSearchSpecificationParameter(), new UserSearchReader(), specification);
		}

		public IPagedList<User, UserSearchSpecification> GetPaged(UserSearchSpecification specification)
		{
			return base.GetPaged(Tables.UsersSearches, new UserSearchSpecificationParameter(), new UserReader(), specification);
		}

		public void Insert(UserSearch search)
		{
			base.Insert(Tables.UsersSearches, new UserSearchParameter(), search);
		}

		public void Update(UserSearch search)
		{
			base.Update(Tables.UsersSearches, new UserSearchParameter(), search);
		}

		public void DeleteExpired()
		{
			using (var connection = base.Connection())
			{
				using (var command = new SqlCommand("dbo.{0}_Delete".Fmt(Tables.UsersSearches), connection))
				{
					command.CommandType = CommandType.StoredProcedure;

					command.Parameters.Add("@Updated", SqlDbType.DateTime).Value = DateTime.Now.AddMinutes(-15);

					connection.Open();

					command.ExecuteNonQuery();

					connection.Close();
				}
			}
		}
	}
}